Figured it out.

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject:

Figured it out.

It's crude but it works.

For any given Part, you need to know all of the items it belongs to.

UnitPN
ModulePN1
ComponentPN1
ComponentPN2

The trick is to build a key for each item.
PN Key
UnitPN UnitPN
ModulePN1 UnitPN + ModulePN1
ComponentPN1 UnitPN + ModulePN1 + ComponentPN1

Now convert each of these into a list where the ListTag is the 'key' and the value is going to be used as the Excel row number
For i = 0 to <number of parts)
RowNumber(Key(i)) = i
Next

Do this for both the AD and AB BOM structures.

Then grab each AD item and see if there is a corresponding item in the AB list.
If there's a match, then the AB and AD lists match and we write out the AB data on the correct AD row.
If there isn't a match, we flag that AD row as 'item not installed'.

Since each item in the list can have a unique key, we don't run into the problem of knowing where any given serialized item lives in the AB structure.

If anyone knows of a less convoluted method to make this work, I'm all ears.

Doug

Addendum 10.Apr.2012 - I spoke to our Oracle/ERP guy today and it seems that this general concept is identical to what Oracle does. They use synonyms for the PN that relate to the item's indent level rather than concatenating the PNs into a unique key but the idea is the same.

Holy crap...I just built and BOM! ;-)

Feedback response number WEBB8T2QA2 created by ~Martha Lopjipyskioden on 04/04/2012

Return to top

Seeking help with a BOM and Configu... (~Martha Lopjipy... 4.Apr.12)

. . Figured it out. (~Martha Lopjipy... 4.Apr.12)

Printer-friendly

Search this forum

Member Tools

RSS Feeds

RSS feeds

	All forum posts RSS
	All main topics RSS